{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Year 1-6","Year 7-12","Year 13-18","Year 19-24","Year 25-30","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Year 1-6","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",156000,null,"Payment",1722.14,"Total",2197.1400000000003]
[null,null,null,"Rate",0.05875,null,"Taxes",275,"Mom",750]
[null,null,null,"Months",120,null,"Maintainence",100,"Grandma",750]
[null,null,null,"Years",10,null,"Main. Man",0,"Us",697.1400000000003]
[null,null,null,"Payment",-1722.14,null,"Condo Fee",100]
[]
[]
[2002,null,null,"Total","Loan",null,2005,null,null,"Total","Loan"]
["Year 1","Principle","Interest","Payment","Balance",null,"Year 4","Principle","Interest","Payment","Balance"]
["Payment 1",958.39,763.75,1722.1399999999999,155041.61,null,"Payment 1",1142.62,579.52,1722.1399999999999,117228.4300000001]
["Payment 2",963.08,759.06,1722.1399999999999,154078.53,null,"Payment 2",1148.21,573.93,1722.1399999999999,116080.22000000009]
["Payment 3",967.8,754.34,1722.1399999999999,153110.73,null,"Payment 3",1153.83,568.31,1722.1399999999999,114926.39000000009]
["Payment 4",972.54,749.6,1722.1399999999999,152138.19,null,"Payment 4",1159.48,562.66,1722.1399999999999,113766.91000000009]
["Payment 5",977.3,744.84,1722.1399999999999,151160.89,null,"Payment 5",1165.16,556.98,1722.14,112601.75000000009]
["Payment 6",982.08,740.06,1722.1399999999999,150178.81000000003,null,"Payment 6",1170.86,551.28,1722.1399999999999,111430.89000000009]
["Payment 7",986.89,735.25,1722.1399999999999,149191.92,null,"Payment 7",1176.59,545.55,1722.1399999999999,110254.30000000009]
["Payment 8",991.72,730.42,1722.1399999999999,148200.2,null,"Payment 8",1182.35,539.79,1722.1399999999999,109071.95000000008]
["Payment 9",996.58,725.56,1722.1399999999999,147203.62000000002,null,"Payment 9",1188.14,534,1722.14,107883.81000000008]
["Payment 10",1001.46,720.68,1722.1399999999999,146202.16000000003,null,"Payment 10",1193.96,528.18,1722.1399999999999,106689.85000000008]
["Payment 11",1006.36,715.78,1722.1399999999999,145195.80000000005,null,"Payment 11",1199.8,522.34,1722.1399999999999,105490.05000000008]
["Payment 12",1011.29,710.85,1722.1399999999999,144184.51000000004,null,"Payment 12",1205.68,516.46,1722.14,104284.37000000008]
["     Gift",0,null,0,144184.51000000004,null,"     Gift",0,null,0,104284.37000000008]
["Total Year 1",11815.490000000002,8850.189999999999,20665.679999999997,null,null,"Total Year 4",14086.679999999997,6579,20665.679999999997]
[]
[2003,null,null,"Total","Loan",null,2006,null,null,"Total","Loan"]
["Year 2","Principle","Interest","Payment","Balance",null,"Year 5","Principle","Interest","Payment","Balance"]
["Payment 1",1016.24,705.9,1722.1399999999999,143168.27000000005,null,"Payment 1",1211.58,510.56,1722.1399999999999,103072.79000000008]
["Payment 2",1021.21,700.93,1722.1399999999999,142147.06000000006,null,"Payment 2",1217.51,504.63,1722.1399999999999,101855.28000000009]
["Payment 3",1026.21,695.93,1722.1399999999999,141120.85000000006,null,"Payment 3",1223.47,498.67,1722.14,100631.81000000008]
["Payment 4",1031.24,690.9,1722.1399999999999,140089.61000000007,null,"Payment 4",1229.46,492.68,1722.14,99402.35000000008]
["Payment 5",1036.28,685.86,1722.1399999999999,139053.33000000007,null,"Payment 5",1235.48,486.66,1722.14,98166.87000000008]
["Payment 6",1041.36,680.78,1722.1399999999999,138011.9700000001,null,"Payment 6",1241.53,480.61,1722.1399999999999,96925.34000000008]
["Payment 7",1046.46,675.68,1722.1399999999999,136965.5100000001,null,"Payment 7",1247.61,474.53,1722.1399999999999,95677.73000000008]
["Payment 8",1051.58,670.56,1722.1399999999999,135913.9300000001,null,"Payment 8",1253.72,468.42,1722.14,94424.01000000008]
["Payment 9",1056.73,665.41,1722.1399999999999,134857.2000000001,null,"Payment 9",1259.86,462.28,1722.1399999999999,93164.15000000008]
["Payment 10",1061.9,660.24,1722.14,133795.3000000001,null,"Payment 10",1266.02,456.12,1722.1399999999999,91898.13000000008]
["Payment 11",1067.1,655.04,1722.1399999999999,132728.2000000001,null,"Payment 11",1272.22,449.92,1722.14,90625.91000000008]
["Payment 12",1072.32,649.82,1722.1399999999999,131655.8800000001,null,"Payment 12",1278.45,443.69,1722.14,89347.46000000008]
["     Gift",0,null,0,131655.8800000001,null,"     Gift",0,null,0,89347.46000000008]
["Total Year 2",12528.629999999997,8137.05,20665.679999999997,null,null,"Total Year 5",14936.91,5728.7699999999995,20665.679999999997]
[]
[2004,null,null,"Total","Loan",null,2007,null,null,"Total","Loan"]
["Year 3","Principle","Interest","Payment","Balance",null,"Year 6","Principle","Interest","Payment","Balance"]
["Payment 1",1077.57,644.57,1722.1399999999999,130578.31000000008,null,"Payment 1",1284.71,437.43,1722.14,88062.75000000007]
["Payment 2",1082.85,639.29,1722.1399999999999,129495.46000000008,null,"Payment 2",1291,431.14,1722.1399999999999,86771.75000000007]
["Payment 3",1088.15,633.99,1722.14,128407.31000000008,null,"Payment 3",1297.32,424.82,1722.1399999999999,85474.43000000007]
["Payment 4",1093.48,628.66,1722.1399999999999,127313.83000000009,null,"Payment 4",1303.67,418.47,1722.14,84170.76000000007]
["Payment 5",1098.83,623.31,1722.1399999999999,126215.00000000009,null,"Payment 5",1310.05,412.09,1722.1399999999999,82860.71000000006]
["Payment 6",1104.21,617.93,1722.1399999999999,125110.79000000008,null,"Payment 6",1316.47,405.67,1722.14,81544.24000000006]
["Payment 7",1109.62,612.52,1722.1399999999999,124001.17000000009,null,"Payment 7",1322.91,399.23,1722.14,80221.33000000006]
["Payment 8",1115.05,607.09,1722.1399999999999,122886.12000000008,null,"Payment 8",1329.39,392.75,1722.14,78891.94000000006]
["Payment 9",1120.51,601.63,1722.1399999999999,121765.61000000009,null,"Payment 9",1335.9,386.24,1722.14,77556.04000000007]
["Payment 10",1126,596.14,1722.1399999999999,120639.61000000009,null,"Payment 10",1342.44,379.7,1722.14,76213.60000000006]
["Payment 11",1131.51,590.63,1722.1399999999999,119508.1000000001,null,"Payment 11",1349.01,373.13,1722.1399999999999,74864.59000000007]
["Payment 12",1137.05,585.09,1722.1399999999999,118371.05000000009,null,"Payment 12",1355.62,366.52,1722.1399999999999,73508.97000000007]
["     Gift",0,null,0,118371.05000000009,null,"     Gift",0,null,0,73508.97000000007]
["Total Year 3",13284.83,7380.850000000001,20665.679999999997,null,null,"Total Year 6",15838.490000000002,4827.1900000000005,20665.679999999997]

{"sheet":"Year 7-12","index":1,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",156000]
[null,null,null,"Rate",0.05875]
[null,null,null,"Months",120]
[null,null,null,"Years",10]
[null,null,null,"Payment",-1722.14]
[]
[]
[2007,null,null,"Total","Loan",null,2009,null,null,"Total","Loan"]
["Year 7","Principle","Interest","Payment","Balance",null,"Year 10","Principle","Interest","Payment","Balance"]
["Payment 1",1362.25,359.89,1722.1399999999999,72146.72000000007,null,"Payment 1",1624.11,98.03,1722.1399999999999,18399.210000000065]
["Payment 2",1368.92,353.22,1722.14,70777.80000000008,null,"Payment 2",1632.06,90.08,1722.1399999999999,16767.150000000063]
["Payment 3",1375.62,346.52,1722.1399999999999,69402.18000000008,null,"Payment 3",1640.05,82.09,1722.1399999999999,15127.100000000064]
["Payment 4",1382.36,339.78,1722.1399999999999,68019.82000000008,null,"Payment 4",1648.08,74.06,1722.1399999999999,13479.020000000064]
["Payment 5",1389.13,333.01,1722.14,66630.69000000008,null,"Payment 5",1656.15,65.99,1722.14,11822.870000000064]
["Payment 6",1395.93,326.21,1722.14,65234.760000000075,null,"Payment 6",1664.26,57.88,1722.14,10158.610000000064]
["Payment 7",1402.76,319.38,1722.1399999999999,63832.00000000007,null,"Payment 7",1672.41,49.73,1722.14,8486.200000000064]
["Payment 8",1409.63,312.51,1722.14,62422.370000000075,null,"Payment 8",1680.59,41.55,1722.1399999999999,6805.610000000064]
["Payment 9",1416.53,305.61,1722.1399999999999,61005.84000000008,null,"Payment 9",1688.82,33.32,1722.1399999999999,5116.7900000000645]
["Payment 10",1423.47,298.67,1722.14,59582.370000000075,null,"Payment 10",1697.09,25.05,1722.1399999999999,3419.7000000000644]
["Payment 11",1430.43,291.71,1722.14,58151.940000000075,null,"Payment 11",1705.4,16.74,1722.14,1714.3000000000643]
["Payment 12",1437.44,284.7,1722.14,56714.50000000007,null,"Payment 12",1713.75,8.39,1722.14,0.5500000000643013]
["Total Year 7",16794.469999999998,3871.2100000000005,20665.679999999997,null,null,"Total Year 10",20022.77,642.91,20665.679999999997]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
[2008,"Principle","Interest","Payment","Balance",null,2010,"Principle","Interest","Payment","Balance"]
["Payment 1",1444.48,277.66,1722.14,55270.02000000007,null,"Payment 1",1722.14,0,1722.14,-1721.5899999999358]
["Payment 2",1451.55,270.59,1722.1399999999999,53818.47000000007,null,"Payment 2",1730.57,-8.43,1722.1399999999999,-3452.1599999999357]
["Payment 3",1458.65,263.49,1722.14,52359.820000000065,null,"Payment 3",1739.04,-16.9,1722.1399999999999,-5191.199999999935]
["Payment 4",1465.8,256.34,1722.1399999999999,50894.02000000006,null,"Payment 4",1747.56,-25.42,1722.1399999999999,-6938.759999999935]
["Payment 5",1472.97,249.17,1722.14,49421.05000000006,null,"Payment 5",1756.11,-33.97,1722.1399999999999,-8694.869999999935]
["Payment 6",1480.18,241.96,1722.14,47940.87000000006,null,"Payment 6",1764.71,-42.57,1722.14,-10459.579999999936]
["Payment 7",1487.43,234.71,1722.14,46453.44000000006,null,"Payment 7",1773.35,-51.21,1722.1399999999999,-12232.929999999937]
["Payment 8",1494.71,227.43,1722.14,44958.73000000006,null,"Payment 8",1782.03,-59.89,1722.1399999999999,-14014.959999999937]
["Payment 9",1502.03,220.11,1722.1399999999999,43456.70000000006,null,"Payment 9",1790.75,-68.61,1722.14,-15805.709999999937]
["Payment 10",1509.38,212.76,1722.14,41947.320000000065,null,"Payment 10",1799.52,-77.38,1722.1399999999999,-17605.229999999938]
["Payment 11",1516.77,205.37,1722.1399999999999,40430.55000000007,null,"Payment 11",1808.33,-86.19,1722.1399999999999,-19413.55999999994]
["Payment 12",1524.2,197.94,1722.14,38906.35000000007,null,"Payment 12",1817.19,-95.05,1722.14,-21230.749999999938]
["Total Year 8",17808.15,2857.53,20665.679999999997,null,null,"Total Year 11",21231.3,-565.62,20665.679999999997]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
[2009,"Principle","Interest","Payment","Balance",null,2011,"Principle","Interest","Payment","Balance"]
["Payment 1",1531.66,190.48,1722.14,37374.69000000007,null,"Payment 1",1826.08,-103.94,1722.1399999999999,-23056.829999999936]
["Payment 2",1539.16,182.98,1722.14,35835.530000000064,null,"Payment 2",1835.02,-112.88,1722.1399999999999,-24891.849999999937]
["Payment 3",1546.7,175.44,1722.14,34288.83000000007,null,"Payment 3",1844.01,-121.87,1722.1399999999999,-26735.859999999935]
["Payment 4",1554.27,167.87,1722.1399999999999,32734.560000000067,null,"Payment 4",1853.03,-130.89,1722.1399999999999,-28588.889999999934]
["Payment 5",1561.88,160.26,1722.14,31172.680000000066,null,"Payment 5",1862.11,-139.97,1722.1399999999999,-30450.999999999935]
["Payment 6",1569.52,152.62,1722.1399999999999,29603.160000000065,null,"Payment 6",1871.22,-149.08,1722.14,-32322.219999999936]
["Payment 7",1577.21,144.93,1722.14,28025.950000000066,null,"Payment 7",1880.38,-158.24,1722.14,-34202.59999999993]
["Payment 8",1584.93,137.21,1722.14,26441.020000000066,null,"Payment 8",1889.59,-167.45,1722.1399999999999,-36092.18999999993]
["Payment 9",1592.69,129.45,1722.14,24848.330000000067,null,"Payment 9",1898.84,-176.7,1722.1399999999999,-37991.029999999926]
["Payment 10",1600.49,121.65,1722.14,23247.840000000066,null,"Payment 10",1908.14,-186,1722.14,-39899.169999999925]
["Payment 11",1608.32,113.82,1722.1399999999999,21639.520000000066,null,"Payment 11",1917.48,-195.34,1722.14,-41816.64999999993]
["Payment 12",1616.2,105.94,1722.14,20023.320000000065,null,"Payment 12",1926.87,-204.73,1722.1399999999999,-43743.51999999993]
["Total Year 9",18883.030000000002,1782.6500000000003,20665.679999999997,null,null,"Total Year 12",22512.769999999997,-1847.09,20665.679999999997]

{"sheet":"Year 13-18","index":2,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",156000]
[null,null,null,"Rate",0.05875]
[null,null,null,"Months",120]
[null,null,null,"Years",10]
[null,null,null,"Payment",-1722.14]
[]
[]
[2011,null,null,"Total","Loan",null,2013,null,null,"Total","Loan"]
["Year 13","Principle","Interest","Payment","Balance",null,"Year 16","Principle","Interest","Payment","Balance"]
["Payment 1",1936.3,-214.16,1722.1399999999999,-45679.819999999934,null,"Payment 1",2308.5,-586.36,1722.1399999999999,-122076.35999999987]
["Payment 2",1945.78,-223.64,1722.1399999999999,-47625.59999999993,null,"Payment 2",2319.81,-597.67,1722.1399999999999,-124396.16999999987]
["Payment 3",1955.31,-233.17,1722.1399999999999,-49580.90999999993,null,"Payment 3",2331.16,-609.02,1722.1399999999999,-126727.32999999987]
["Payment 4",1964.88,-242.74,1722.14,-51545.78999999993,null,"Payment 4",2342.58,-620.44,1722.1399999999999,-129069.90999999987]
["Payment 5",1974.5,-252.36,1722.1399999999999,-53520.28999999993,null,"Payment 5",2354.04,-631.9,1722.1399999999999,-131423.94999999987]
["Payment 6",1984.17,-262.03,1722.14,-55504.45999999993,null,"Payment 6",2365.57,-643.43,1722.1400000000003,-133789.51999999987]
["Payment 7",1993.88,-271.74,1722.14,-57498.339999999924,null,"Payment 7",2377.15,-655.01,1722.14,-136166.66999999987]
["Payment 8",2003.64,-281.5,1722.14,-59501.97999999992,null,"Payment 8",2388.79,-666.65,1722.1399999999999,-138555.45999999988]
["Payment 9",2013.45,-291.31,1722.14,-61515.42999999992,null,"Payment 9",2400.48,-678.34,1722.1399999999999,-140955.9399999999]
["Payment 10",2023.31,-301.17,1722.1399999999999,-63538.73999999992,null,"Payment 10",2412.24,-690.1,1722.1399999999999,-143368.17999999988]
["Payment 11",2033.22,-311.08,1722.14,-65571.95999999992,null,"Payment 11",2424.05,-701.91,1722.1400000000003,-145792.22999999986]
["Payment 12",2043.17,-321.03,1722.14,-67615.12999999992,null,"Payment 12",2435.91,-713.77,1722.1399999999999,-148228.13999999987]
["Total Year 13",23871.61,-3205.9300000000003,20665.679999999997,null,null,"Total Year 16",28460.28,-7794.6,20665.679999999997]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
[2012,"Principle","Interest","Payment","Balance",null,2014,"Principle","Interest","Payment","Balance"]
["Payment 1",2053.17,-331.03,1722.14,-69668.29999999992,null,"Payment 1",2447.84,-725.7,1722.14,-150675.97999999986]
["Payment 2",2063.22,-341.08,1722.1399999999999,-71731.51999999992,null,"Payment 2",2459.82,-737.68,1722.1400000000003,-153135.79999999987]
["Payment 3",2073.33,-351.19,1722.1399999999999,-73804.84999999992,null,"Payment 3",2471.87,-749.73,1722.1399999999999,-155607.66999999987]
["Payment 4",2083.48,-361.34,1722.14,-75888.32999999991,null,"Payment 4",2483.97,-761.83,1722.1399999999999,-158091.63999999987]
["Payment 5",2093.68,-371.54,1722.1399999999999,-77982.00999999991,null,"Payment 5",2496.13,-773.99,1722.14,-160587.76999999987]
["Payment 6",2103.93,-381.79,1722.1399999999999,-80085.9399999999,null,"Payment 6",2508.35,-786.21,1722.1399999999999,-163096.11999999988]
["Payment 7",2114.23,-392.09,1722.14,-82200.1699999999,null,"Payment 7",2520.63,-798.49,1722.14,-165616.74999999988]
["Payment 8",2124.58,-402.44,1722.1399999999999,-84324.7499999999,null,"Payment 8",2532.97,-810.83,1722.1399999999999,-168149.71999999988]
["Payment 9",2134.98,-412.84,1722.14,-86459.7299999999,null,"Payment 9",2545.37,-823.23,1722.1399999999999,-170695.08999999988]
["Payment 10",2145.43,-423.29,1722.1399999999999,-88605.15999999989,null,"Payment 10",2557.83,-835.69,1722.1399999999999,-173252.91999999987]
["Payment 11",2155.94,-433.8,1722.14,-90761.09999999989,null,"Payment 11",2570.36,-848.22,1722.14,-175823.27999999985]
["Payment 12",2166.49,-444.35,1722.1399999999999,-92927.5899999999,null,"Payment 12",2582.94,-860.8,1722.14,-178406.21999999986]
["Total Year 14",25312.46,-4646.780000000001,20665.679999999997,null,null,"Total Year 17",30178.079999999998,-9512.4,20665.679999999997]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
[2013,"Principle","Interest","Payment","Balance",null,2015,"Principle","Interest","Payment","Balance"]
["Payment 1",2177.1,-454.96,1722.1399999999999,-95104.6899999999,null,"Payment 1",2595.59,-873.45,1722.14,-181001.80999999985]
["Payment 2",2187.76,-465.62,1722.1400000000003,-97292.4499999999,null,"Payment 2",2608.29,-886.15,1722.1399999999999,-183610.09999999986]
["Payment 3",2198.47,-476.33,1722.1399999999999,-99490.9199999999,null,"Payment 3",2621.06,-898.92,1722.1399999999999,-186231.15999999986]
["Payment 4",2209.23,-487.09,1722.14,-101700.14999999989,null,"Payment 4",2633.9,-911.76,1722.14,-188865.05999999985]
["Payment 5",2220.05,-497.91,1722.14,-103920.1999999999,null,"Payment 5",2646.79,-924.65,1722.1399999999999,-191511.84999999986]
["Payment 6",2230.92,-508.78,1722.14,-106151.1199999999,null,"Payment 6",2659.75,-937.61,1722.1399999999999,-194171.59999999986]
["Payment 7",2241.84,-519.7,1722.14,-108392.95999999989,null,"Payment 7",2672.77,-950.63,1722.1399999999999,-196844.36999999985]
["Payment 8",2252.81,-530.67,1722.1399999999999,-110645.76999999989,null,"Payment 8",2685.86,-963.72,1722.14,-199530.22999999984]
["Payment 9",2263.84,-541.7,1722.14,-112909.60999999988,null,"Payment 9",2699.01,-976.87,1722.1400000000003,-202229.23999999985]
["Payment 10",2274.93,-552.79,1722.1399999999999,-115184.53999999988,null,"Payment 10",2712.22,-990.08,1722.1399999999999,-204941.45999999985]
["Payment 11",2286.06,-563.92,1722.1399999999999,-117470.59999999987,null,"Payment 11",2725.5,-1003.36,1722.1399999999999,-207666.95999999985]
["Payment 12",2297.26,-575.12,1722.1400000000003,-119767.85999999987,null,"Payment 12",2738.84,-1016.7,1722.14,-210405.79999999984]
["Total Year 15",26840.270000000004,-6174.589999999999,20665.679999999997,null,null,"Total Year 18",31999.580000000005,-11333.900000000001,20665.679999999997]

{"sheet":"Year 19-24","index":3,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",156000]
[null,null,null,"Rate",0.05875]
[null,null,null,"Months",120]
[null,null,null,"Years",10]
[null,null,null,"Payment",-1722.14]
[]
[]
[2015,null,null,"Total","Loan",null,2017,null,null,"Total","Loan"]
["Year 19","Principle","Interest","Payment","Balance",null,"Year 22","Principle","Interest","Payment","Balance"]
["Payment 1",2752.25,-1030.11,1722.14,-213158.04999999984,null,"Payment 1",3281.3,-1559.16,1722.14,-321747.7899999999]
["Payment 2",2765.73,-1043.59,1722.14,-215923.77999999985,null,"Payment 2",3297.36,-1575.22,1722.14,-325045.1499999999]
["Payment 3",2779.27,-1057.13,1722.1399999999999,-218703.04999999984,null,"Payment 3",3313.51,-1591.37,1722.1400000000003,-328358.6599999999]
["Payment 4",2792.87,-1070.73,1722.1399999999999,-221495.91999999984,null,"Payment 4",3329.73,-1607.59,1722.14,-331688.3899999999]
["Payment 5",2806.55,-1084.41,1722.14,-224302.46999999983,null,"Payment 5",3346.03,-1623.89,1722.14,-335034.4199999999]
["Payment 6",2820.29,-1098.15,1722.1399999999999,-227122.75999999983,null,"Payment 6",3362.41,-1640.27,1722.1399999999999,-338396.8299999999]
["Payment 7",2834.1,-1111.96,1722.1399999999999,-229956.85999999984,null,"Payment 7",3378.87,-1656.73,1722.1399999999999,-341775.6999999999]
["Payment 8",2847.97,-1125.83,1722.1399999999999,-232804.82999999984,null,"Payment 8",3395.42,-1673.28,1722.14,-345171.1199999999]
["Payment 9",2861.91,-1139.77,1722.1399999999999,-235666.73999999985,null,"Payment 9",3412.04,-1689.9,1722.1399999999999,-348583.15999999986]
["Payment 10",2875.93,-1153.79,1722.1399999999999,-238542.66999999984,null,"Payment 10",3428.75,-1706.61,1722.14,-352011.90999999986]
["Payment 11",2890.01,-1167.87,1722.1400000000003,-241432.67999999985,null,"Payment 11",3445.53,-1723.39,1722.14,-355457.4399999999]
["Payment 12",2904.15,-1182.01,1722.14,-244336.82999999984,null,"Payment 12",3462.4,-1740.26,1722.14,-358919.8399999999]
["Total Year 19",33931.03,-13265.35,20665.679999999997,null,null,"Total Year 22",40453.35,-19787.67,20665.679999999997]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
[2016,"Principle","Interest","Payment","Balance",null,2018,"Principle","Interest","Payment","Balance"]
["Payment 1",2918.37,-1196.23,1722.1399999999999,-247255.19999999984,null,"Payment 1",3479.35,-1757.21,1722.1399999999999,-362399.1899999999]
["Payment 2",2932.66,-1210.52,1722.1399999999999,-250187.85999999984,null,"Payment 2",3496.39,-1774.25,1722.1399999999999,-365895.5799999999]
["Payment 3",2947.02,-1224.88,1722.1399999999999,-253134.87999999983,null,"Payment 3",3513.5,-1791.36,1722.14,-369409.0799999999]
["Payment 4",2961.45,-1239.31,1722.1399999999999,-256096.32999999984,null,"Payment 4",3530.71,-1808.57,1722.14,-372939.7899999999]
["Payment 5",2975.94,-1253.8,1722.14,-259072.26999999984,null,"Payment 5",3547.99,-1825.85,1722.1399999999999,-376487.7799999999]
["Payment 6",2990.51,-1268.37,1722.1400000000003,-262062.77999999985,null,"Payment 6",3565.36,-1843.22,1722.14,-380053.1399999999]
["Payment 7",3005.16,-1283.02,1722.1399999999999,-265067.9399999998,null,"Payment 7",3582.82,-1860.68,1722.14,-383635.9599999999]
["Payment 8",3019.87,-1297.73,1722.1399999999999,-268087.8099999998,null,"Payment 8",3600.36,-1878.22,1722.14,-387236.3199999999]
["Payment 9",3034.65,-1312.51,1722.14,-271122.45999999985,null,"Payment 9",3617.98,-1895.84,1722.14,-390854.2999999999]
["Payment 10",3049.51,-1327.37,1722.1400000000003,-274171.96999999986,null,"Payment 10",3635.7,-1913.56,1722.1399999999999,-394489.9999999999]
["Payment 11",3064.44,-1342.3,1722.14,-277236.40999999986,null,"Payment 11",3653.5,-1931.36,1722.14,-398143.4999999999]
["Payment 12",3079.44,-1357.3,1722.14,-280315.84999999986,null,"Payment 12",3671.38,-1949.24,1722.14,-401814.8799999999]
["Total Year 20",35979.020000000004,-15313.34,20665.679999999997,null,null,"Total Year 23",42895.04,-22229.36,20665.679999999997]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
[2017,"Principle","Interest","Payment","Balance",null,2019,"Principle","Interest","Payment","Balance"]
["Payment 1",3094.52,-1372.38,1722.1399999999999,-283410.3699999999,null,"Payment 1",3689.36,-1967.22,1722.14,-405504.2399999999]
["Payment 2",3109.67,-1387.53,1722.14,-286520.03999999986,null,"Payment 2",3707.42,-1985.28,1722.14,-409211.65999999986]
["Payment 3",3124.89,-1402.75,1722.1399999999999,-289644.9299999999,null,"Payment 3",3725.57,-2003.43,1722.14,-412937.22999999986]
["Payment 4",3140.19,-1418.05,1722.14,-292785.1199999999,null,"Payment 4",3743.81,-2021.67,1722.1399999999999,-416681.03999999986]
["Payment 5",3155.57,-1433.43,1722.14,-295940.6899999999,null,"Payment 5",3762.14,-2040,1722.1399999999999,-420443.1799999999]
["Payment 6",3171.02,-1448.88,1722.1399999999999,-299111.7099999999,null,"Payment 6",3780.56,-2058.42,1722.1399999999999,-424223.7399999999]
["Payment 7",3186.54,-1464.4,1722.1399999999999,-302298.2499999999,null,"Payment 7",3799.07,-2076.93,1722.1400000000003,-428022.8099999999]
["Payment 8",3202.14,-1480,1722.1399999999999,-305500.3899999999,null,"Payment 8",3817.67,-2095.53,1722.1399999999999,-431840.47999999986]
["Payment 9",3217.82,-1495.68,1722.14,-308718.2099999999,null,"Payment 9",3836.36,-2114.22,1722.1400000000003,-435676.83999999985]
["Payment 10",3233.57,-1511.43,1722.14,-311951.7799999999,null,"Payment 10",3855.14,-2133,1722.1399999999999,-439531.97999999986]
["Payment 11",3249.4,-1527.26,1722.14,-315201.17999999993,null,"Payment 11",3874.02,-2151.88,1722.1399999999999,-443405.9999999999]
["Payment 12",3265.31,-1543.17,1722.1399999999999,-318466.48999999993,null,"Payment 12",3892.98,-2170.84,1722.1399999999999,-447298.97999999986]
["Total Year 21",38150.64,-17484.96,20665.679999999997,null,null,"Total Year 24",45484.1,-24818.420000000002,20665.679999999997]

{"sheet":"Year 25-30","index":4,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",156000]
[null,null,null,"Rate",0.05875]
[null,null,null,"Months",120]
[null,null,null,"Years",10]
[null,null,null,"Payment",-1722.14]
[]
[]
[2020,null,null,"Total","Loan",null,2023,null,null,"Total","Loan"]
["Year 25","Principle","Interest","Payment","Balance",null,"Year 28","Principle","Interest","Payment","Balance"]
["Payment 1",3912.04,-2189.9,1722.1399999999999,-451211.01999999984,null,"Payment 1",4664.03,-2941.89,1722.1399999999999,-605560.0799999998]
["Payment 2",3931.19,-2209.05,1722.1399999999999,-455142.20999999985,null,"Payment 2",4686.86,-2964.72,1722.1399999999999,-610246.9399999998]
["Payment 3",3950.44,-2228.3,1722.1399999999999,-459092.64999999985,null,"Payment 3",4709.81,-2987.67,1722.1400000000003,-614956.7499999999]
["Payment 4",3969.78,-2247.64,1722.1400000000003,-463062.4299999999,null,"Payment 4",4732.87,-3010.73,1722.1399999999999,-619689.6199999999]
["Payment 5",3989.22,-2267.08,1722.1399999999999,-467051.64999999985,null,"Payment 5",4756.04,-3033.9,1722.1399999999999,-624445.6599999999]
["Payment 6",4008.75,-2286.61,1722.1399999999999,-471060.39999999985,null,"Payment 6",4779.32,-3057.18,1722.1399999999999,-629224.9799999999]
["Payment 7",4028.37,-2306.23,1722.1399999999999,-475088.76999999984,null,"Payment 7",4802.72,-3080.58,1722.1400000000003,-634027.6999999998]
["Payment 8",4048.1,-2325.96,1722.1399999999999,-479136.8699999998,null,"Payment 8",4826.23,-3104.09,1722.1399999999994,-638853.9299999998]
["Payment 9",4067.91,-2345.77,1722.1399999999999,-483204.7799999998,null,"Payment 9",4849.86,-3127.72,1722.1399999999999,-643703.7899999998]
["Payment 10",4087.83,-2365.69,1722.1399999999999,-487292.6099999998,null,"Payment 10",4873.61,-3151.47,1722.1399999999999,-648577.3999999998]
["Payment 11",4107.84,-2385.7,1722.1400000000003,-491400.44999999984,null,"Payment 11",4897.47,-3175.33,1722.1400000000003,-653474.8699999998]
["Payment 12",4127.95,-2405.81,1722.1399999999999,-495528.39999999985,null,"Payment 12",4921.44,-3199.3,1722.1399999999994,-658396.3099999997]
["Total Year 25",48229.42,-27563.74,20665.679999999997,null,null,"Total Year 28",57500.26000000001,-36834.58,20665.679999999997]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
[2021,"Principle","Interest","Payment","Balance",null,2024,"Principle","Interest","Payment","Balance"]
["Payment 1",4148.16,-2426.02,1722.1399999999999,-499676.5599999998,null,"Payment 1",4945.54,-3223.4,1722.1399999999999,-663341.8499999997]
["Payment 2",4168.47,-2446.33,1722.1400000000003,-503845.0299999998,null,"Payment 2",4969.75,-3247.61,1722.1399999999999,-668311.5999999997]
["Payment 3",4188.88,-2466.74,1722.1400000000003,-508033.9099999998,null,"Payment 3",4994.08,-3271.94,1722.1399999999999,-673305.6799999997]
["Payment 4",4209.39,-2487.25,1722.1400000000003,-512243.2999999998,null,"Payment 4",5018.53,-3296.39,1722.1399999999999,-678324.2099999997]
["Payment 5",4230,-2507.86,1722.1399999999999,-516473.2999999998,null,"Payment 5",5043.1,-3320.96,1722.1400000000003,-683367.3099999997]
["Payment 6",4250.71,-2528.57,1722.1399999999999,-520724.00999999983,null,"Payment 6",5067.79,-3345.65,1722.1399999999999,-688435.0999999997]
["Payment 7",4271.52,-2549.38,1722.1400000000003,-524995.5299999998,null,"Payment 7",5092.6,-3370.46,1722.1400000000003,-693527.6999999997]
["Payment 8",4292.43,-2570.29,1722.1400000000003,-529287.9599999998,null,"Payment 8",5117.54,-3395.4,1722.1399999999999,-698645.2399999998]
["Payment 9",4313.45,-2591.31,1722.1399999999999,-533601.4099999998,null,"Payment 9",5142.59,-3420.45,1722.1400000000003,-703787.8299999997]
["Payment 10",4334.56,-2612.42,1722.1400000000003,-537935.9699999999,null,"Payment 10",5167.77,-3445.63,1722.1400000000003,-708955.5999999997]
["Payment 11",4355.78,-2633.64,1722.1399999999999,-542291.7499999999,null,"Payment 11",5193.07,-3470.93,1722.1399999999999,-714148.6699999997]
["Payment 12",4377.11,-2654.97,1722.1399999999999,-546668.8599999999,null,"Payment 12",5218.49,-3496.35,1722.1399999999999,-719367.1599999997]
["Total Year 26",51140.45999999999,-30474.780000000006,20665.679999999997,null,null,"Total Year 29",60970.850000000006,-40305.17,20665.679999999997]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
[2022,"Principle","Interest","Payment","Balance",null,2025,"Principle","Interest","Payment","Balance"]
["Payment 1",4398.54,-2676.4,1722.1399999999999,-551067.3999999999,null,"Payment 1",5244.04,-3521.9,1722.1399999999999,-724611.1999999997]
["Payment 2",4420.07,-2697.93,1722.1399999999999,-555487.4699999999,null,"Payment 2",5269.72,-3547.58,1722.1400000000003,-729880.9199999997]
["Payment 3",4441.71,-2719.57,1722.1399999999999,-559929.1799999998,null,"Payment 3",5295.52,-3573.38,1722.1400000000003,-735176.4399999997]
["Payment 4",4463.46,-2741.32,1722.1399999999999,-564392.6399999998,null,"Payment 4",5321.44,-3599.3,1722.1399999999994,-740497.8799999997]
["Payment 5",4485.31,-2763.17,1722.1400000000003,-568877.9499999998,null,"Payment 5",5347.49,-3625.35,1722.1399999999999,-745845.3699999996]
["Payment 6",4507.27,-2785.13,1722.1400000000003,-573385.2199999999,null,"Payment 6",5373.67,-3651.53,1722.1399999999999,-751219.0399999997]
["Payment 7",4529.34,-2807.2,1722.1400000000003,-577914.5599999998,null,"Payment 7",5399.98,-3677.84,1722.1399999999994,-756619.0199999997]
["Payment 8",4551.51,-2829.37,1722.1400000000003,-582466.0699999998,null,"Payment 8",5426.42,-3704.28,1722.1399999999999,-762045.4399999997]
["Payment 9",4573.8,-2851.66,1722.1400000000003,-587039.8699999999,null,"Payment 9",5452.99,-3730.85,1722.1399999999999,-767498.4299999997]
["Payment 10",4596.19,-2874.05,1722.1399999999994,-591636.0599999998,null,"Payment 10",5479.68,-3757.54,1722.1400000000003,-772978.1099999998]
["Payment 11",4618.69,-2896.55,1722.1399999999994,-596254.7499999998,null,"Payment 11",5506.51,-3784.37,1722.1400000000003,-778484.6199999998]
["Payment 12",4641.3,-2919.16,1722.1400000000003,-600896.0499999998,null,"Payment 12",5533.47,-3811.33,1722.1400000000003,-784018.0899999997]
["Total Year 27",54227.19000000001,-33561.509999999995,20665.679999999997,null,null,"Total Year 30",64650.93,-43985.25,20665.679999999997]

{"sheet":"Sheet2","index":5,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[{"$nulls":6},1]
{"$rows_empty":16}
[{"$nulls":6},2]
{"$rows_empty":15}
[1,{"$nulls":5},3]

{"sheet":"Sheet3","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}